package mudbconnection;

import java.util.List;

import muobject.StudentSummary;

public interface DBStudentSummary {
	
	public Boolean ExistDataTable();
	
	public List<StudentSummary> getAllStudentSummary();
	
	public List<StudentSummary> getStudentSummaryFromOtherTable(String year, String stno);
	
	public boolean setStudentSummary (StudentSummary studentSummary);
	
	public boolean deleteAllStudentSummary();
	
	public int getStudentSexScoreMaxMin(String sex, String item, String type);
	
	public int getStudentSexScoreCount(String sex, String item, double lower, double height);
	
	public double getStudentSexScoreAvg(String sex, String item);

}
